﻿CREATE TABLE [dbo].[Web] (
    [WebID]             UNIQUEIDENTIFIER NOT NULL,
    [SiteCollectionID]  UNIQUEIDENTIFIER NOT NULL,
    [ParentWebID]       UNIQUEIDENTIFIER NULL,
    [ServerRelativeUrl] VARCHAR (100)    NULL,
    [Size]              FLOAT (53)       NULL,
    [nrFiles]           BIGINT           NULL,
    [Level]             INT              NULL,
    CONSTRAINT [PK_Web] PRIMARY KEY CLUSTERED ([WebID] ASC),
    CONSTRAINT [FK_Web_SiteCollection] FOREIGN KEY ([SiteCollectionID]) REFERENCES [dbo].[SiteCollection] ([SiteCollectionID])
);

